This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C52ED4.7A096E30
Content-Type: text/plain;
charset="iso-8859-1"
Apologies for those who are in both mailing lists.
Hi All
I am designing a data loader script that can transform data in one table
schema into a new table schema in Postgres for reporting purposes.
I wanted to ask, on a performance issue.
Which is more efficient, in reading in a row of data, and assigning
individual column values to variables, and then inserting a new row into the
new table.
pg_fetch_row
pg_fetch_assoc
pg_fetch_object
pg_fetch_result
pg_fetch_array
Are there performance differences, which are noticeable?
Thanks in advance.
Kind Regards,
Shaun Clements
------_=_NextPart_001_01C52ED4.7A096E30
Content-Type: text/html;
charset="iso-8859-1"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>[GENERAL] PHP SQL</TITLE>
<META content="MSHTML 6.00.2800.1400" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT size=2><SPAN class=901564211-22032005><FONT face=Verdana>Apologies
for those who are in both mailing lists. </FONT></SPAN></FONT></DIV>
<DIV><FONT face=Verdana size=2><SPAN
class=901564211-22032005></SPAN></FONT> </DIV>
<DIV><FONT size=2><SPAN class=901564211-22032005><FONT face=Verdana>Hi
All</FONT></SPAN></FONT></DIV>
<P><FONT size=2>I am designing a data loader script that can transform data in
one table schema into a new table schema in Postgres for reporting
purposes.</FONT></P>
<P><FONT size=2>I wanted to ask, on a performance issue.</FONT> <BR><FONT
size=2>Which is more efficient, in reading in a row of data, and assigning
individual column values to variables, and then inserting a new row into the new
table.</FONT></P>
<P><FONT size=2>pg_fetch_row</FONT> <BR><FONT size=2>pg_fetch_assoc</FONT>
<BR><FONT size=2>pg_fetch_object</FONT> <BR><FONT size=2>pg_fetch_result</FONT>
<BR><FONT size=2>pg_fetch_array</FONT> </P>
<P><FONT size=2>Are there performance differences, which are
noticeable?</FONT> <BR><SPAN class=901564211-22032005><FONT face=Verdana
color=#0000ff size=2><FONT color=#000000>Thanks in
advance.</FONT> </FONT></SPAN></P>
<P><FONT size=2>Kind Regards,</FONT> <BR><FONT size=2>Shaun Clements</FONT>
</P></BODY></HTML>
------_=_NextPart_001_01C52ED4.7A096E30--
